package org.example.entity;

import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

import java.math.BigDecimal;
import java.time.LocalDateTime;

/**
 * 投资收益率数据表实体
 */
@Data
@TableName("investment_return_data")
public class InvestmentReturnData {
    
    @TableId(type = IdType.AUTO)
    private Long id;
    
    @ExcelProperty(value = "放款月份", index = 0)
    private String periodDate;
    
    @ExcelProperty(value = "放款金额", index = 1)
    private BigDecimal investmentAmount;
    
    @ExcelProperty(value = "平均利率", index = 2)
    private BigDecimal averageReturn;
    /**
     * 类别：30+金额、60+金额、90+金额
     */
    private String categoryType;
    
    @ExcelProperty(value = "1", index = 3)
    private BigDecimal period_1;
    
    @ExcelProperty(value = "2", index = 4)
    private BigDecimal period_2;
    
    @ExcelProperty(value = "3", index = 5)
    private BigDecimal period_3;
    
    @ExcelProperty(value = "4", index = 6)
    private BigDecimal period_4;
    
    @ExcelProperty(value = "5", index = 7)
    private BigDecimal period_5;
    
    @ExcelProperty(value = "6", index = 8)
    private BigDecimal period_6;
    
    @ExcelProperty(value = "7", index = 9)
    private BigDecimal period_7;
    
    @ExcelProperty(value = "8", index = 10)
    private BigDecimal period_8;
    
    @ExcelProperty(value = "9", index = 11)
    private BigDecimal period_9;
    
    @ExcelProperty(value = "10", index = 12)
    private BigDecimal period_10;
    
    @ExcelProperty(value = "11", index = 13)
    private BigDecimal period_11;
    
    @ExcelProperty(value = "12", index = 14)
    private BigDecimal period_12;
    
    @ExcelProperty(value = "13", index = 15)
    private BigDecimal period_13;
    
    @ExcelProperty(value = "14", index = 16)
    private BigDecimal period_14;
    
    @ExcelProperty(value = "15", index = 17)
    private BigDecimal period_15;
    
    @ExcelProperty(value = "16", index = 18)
    private BigDecimal period_16;
    
    @ExcelProperty(value = "17", index = 19)
    private BigDecimal period_17;
    
    @ExcelProperty(value = "18", index = 20)
    private BigDecimal period_18;
    
    @ExcelProperty(value = "19", index = 21)
    private BigDecimal period_19;
    
    @ExcelProperty(value = "20", index = 22)
    private BigDecimal period_20;
    
    @ExcelProperty(value = "21", index = 23)
    private BigDecimal period_21;
    
    @ExcelProperty(value = "22", index = 24)
    private BigDecimal period_22;
    
    @ExcelProperty(value = "23", index = 25)
    private BigDecimal period_23;
    
    @ExcelProperty(value = "24", index = 26)
    private BigDecimal period_24;
    
    @ExcelProperty(value = "25", index = 27)
    private BigDecimal period_25;
    
    @ExcelProperty(value = "26", index = 28)
    private BigDecimal period_26;
    
    private LocalDateTime createdTime;
    private LocalDateTime updatedTime;
}
